An Interpretive Study of How Practitioners Use Entity-Relationship Modelling in a Ternary Relationship Situation

This paper discusses the use of interpretive research to learn about the practicality of entityrelationship modelling in ternary relationship situations. The findings can be compared with previous studies of novice modellers who used the same invented scenario. Previous research excluded the interaction between practitioners that would occur during a modelling session because novices were used to complete tasks in isolation. A team of experienced practitioners are shown to use entity-relationship modelling in a business context of social interaction about design. The interaction proves to be a key part of the modelling process. Practitioners ‘talk with the notation’ as well as using the notation to draw a diagram. The entity-relationship model constrains the social interaction because the model provides a way of talking about design. The practitioners use the model to talk about a normalized relational data structure in a way that undermines the idea of the entity-relationship model as an independent conceptual model. The findings show that theories from the field of linguistics explain why the model is used in this design-dependent way and suggest that this dependency may be inevitable. When the design conversation is about a normalized relational data structure there is no benefit to the practitioners from using a special notation for ternary relationships. On the contrary, the practitioner’s design dependence seems to enable them to expose aspects of a domain that do not make business sense. The wider implication is that interpretive research’s role is important in generating insights about the extent to which conceptual modelling is usable by practitioners. Interpretive research highlights the importance of being able to distinguish between ideas about conceptual modelling and ideas about how to apply modelling to practice.